Which type of lock does a record or page get locked immediately?

  1. Home
  2. Back

Source (programming language) - Online Exam Test Papers | Source (programming language) - MCQs[multiple choice questions and answers ] | Source (programming language) - Mock Test Papers | Source (programming language) - Practice Papers | Source (programming language) - Sample Test Papers |

Question:
Which type of lock does a record or page get locked immediately?

1.Pessimistic locking

2.Optimistic locking

3.both (a) and (b)

4.None of these

Posted Date:-2022-11-11 14:47:04

More MCQS Questions and answers

  1. The language used in application programs to request data from the DBMS is referred to as the
  2. A ROLLBACK statement will also release any existing savepoints that may not be in use.
  3. What do you mean by atomicity?
  4. What is 5NF?
  5. What is the maximum possible size of the file in the index allocation scheme of blocks to a file depend on? (Database)
  6. Which of the following forms is considered as adequate for normal relational database design?
  7. A trigger is ?
  8. An unnormalized relation contains values ?
  9. Consider an SQL query SELECT A.Id FROM A WHERE A.Age> All (SELECT B.Age FROM B WHERE B.name = ‘Anay’) The result of this query contains
  10. Database: A condition that led to the development of database was
  11. Database: In second normal form ______________________
  12. Database: Which is not a function of aggregate function?
  13. Database: Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
  14. Database: Which of the following fields in a student file can be used as a primary key?
  15. Databases: The view of total database content is _____
  16. Issuing which type of savepoint will cause the named savepoint to be discarded? (Database)
  17. Primitive operations common to all record management system include ? (Database)
  18. State the concurrency protocols which ensure both conflict serializability and freedom from deadlock 1. 2-phase locking 2. Time-stamp ordering
  19. The functional dependencies for the relational schema student performance (name, courseNo, rollno, grade) is given below : name, courseNo -> grade rollno, courseNo -> grade name -> rollno rollno-> name What is the highest normal form of this relational schema?
  20. What are the important criteria for designing tables?
  21. What are the Report Generators used for?
  22. What is an audit trial? (Database)
  23. What is degree 0 isolation?
  24. What is durability?
  25. What is the highest level in a hierarchy of data organization?
  26. What is truncating a table?
  27. What type of form says “ Each column type is unique ” ?
  28. What type of relationship does a hierarchical schema help to establish between the items of a database?
  29. Which among the following comprises of a complete record of all activities responsible in affecting the database contents for a specific duration?
  30. Which command helps to display schema of a table?
  31. Which is an essential characteristic of a normal form where every determinant in a table must be a candidate key?
  32. Which is the concurrency control protocol that ensure both conflict serializability and freedom from deadlock? (Database)
  33. Which is the major data structure used in RDBMS?
  34. Which normal relational database design the form that is considered adequate?
  35. Which of the following database object does not physically exist? (Database)
  36. Which of the following has a relationship between / among themselves as a functional dependency?
  37. Which of the following is used to define the schema of each database hosted in the DBMS?
  38. Which of the following may lead to an irrecoverable error in a database system?
  39. Which of the following statement is / are not true about normal forms? (Database)
  40. Which one of the following statements is / are true about SQL?
  41. Which SQL keyword is used to remove the duplication of rows from the result set?
  42. Which type of clustering index is defined on the fields?
  43. Which type of lock does a record or page get locked immediately?
  44. Why are B+ trees preferred over binary trees in databases?
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!